home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Object Oriented Applicat…isualAge for C++ for OS/2
/
Object-Oriented Application Development with VisualAGE for C++ for OS2.iso
/
update.ddl
< prev
Wrap
Text File
|
1996-03-08
|
14KB
|
379 lines
INSERT INTO BUYER VALUES('612-45-6798',
'Marc',
'Carrel',
'M',
'M',
5000,
'408-448-4088',
'408-927-5678');
INSERT INTO BUYER VALUES('412-67-8856',
'Isabelle',
'Mauny',
'S',
'F',
4000,
'408-555-6789',
'408-927-1238');
INSERT INTO BUYER VALUES('567-56-1234',
'Peter',
'Jakab',
'M',
'M',
7000,
'445-678-3422',
'434-927-5811');
INSERT INTO BUYER VALUES('123-44-7823',
'Rainer',
'Vetter',
'M',
'M',
8000,
'456-467-6666',
'445-927-2345');
INSERT INTO BUYER VALUES('345-55-1111',
'Paulette',
'Sopper',
'F',
'M',
5000,
'445-423-4333',
'456-927-9876');
INSERT INTO BUYER VALUES('678-22-1118',
'Guido',
'De Simoni',
'M',
'S',
5000,
'408-448-2348',
'466-927-1234');
INSERT INTO BUYER_ADDRESS VALUES('612-45-6798',
'1089 San Thomas Way',
'Almaden',
'San Jose',
'CA',
'95136' );
INSERT INTO BUYER_ADDRESS VALUES('412-67-8856',
'1234 Blossom Hill Road',
'Tenessee',
'Morgan Hill',
'CA',
'92111' );
INSERT INTO BUYER_ADDRESS VALUES('567-56-1234',
'12 Harry Road',
'Tropico',
'Los Gatos',
'CA',
'96786');
INSERT INTO BUYER_ADDRESS VALUES('123-44-7823',
'134 Onmy Way',
'New Island',
'Saratoga',
'CA',
'93245' );
INSERT INTO BUYER_ADDRESS VALUES('345-55-1111',
'456 Quiche Way',
'Castro',
'San Francisco',
'CA',
'96676' );
INSERT INTO BUYER_ADDRESS VALUES('678-22-1118',
'789 5th Avenue',
'Cherry Trees',
'New York',
'NY',
'95676' );
INSERT INTO PREFERENCE VALUES('612-45-6798',
3000,
2000,
300,
200,
2,
4,
1,
'No Heating',
'No Cooling');
INSERT INTO PREFERENCE VALUES('412-67-8856',
4000,
3000,
400,
300,
2,
3,
2,
'Gas',
'No Cooling');
INSERT INTO PREFERENCE VALUES('567-56-1234',
5000,
4000,
500,
400,
3,
2,
2,
'Electric',
'Room Air Conditioner');
INSERT INTO PREFERENCE VALUES('123-44-7823',
6000,
5000,
600,
500,
1,
1,
3,
'Propane Gas',
'Evaporative Cooler');
INSERT INTO PREFERENCE VALUES('345-55-1111',
7000,
6000,
700,
600,
1,
3,
2,
'Solar',
'No Cooling');
INSERT INTO PREFERENCE VALUES('678-22-1118',
8000,
7000,
800,
700,
5,
4,
1,
'Oil',
'Evaporative Cooler');
INSERT INTO BUYER_LOG VALUES('612-45-6798',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO BUYER_LOG VALUES('412-67-8856',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO BUYER_LOG VALUES('567-56-1234',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO BUYER_LOG VALUES('123-44-7823',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO BUYER_LOG VALUES('345-55-1111',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO BUYER_LOG VALUES('678-22-1118',
'1995-12-04-12.12.12.000000',
'1995-12-04-12.12.12.000000');
INSERT INTO PROPERTY VALUES('11111',
800,
10,
5,
3,
'No Heating',
'No Cooling',
'Big House with all the
facilities. Garden a la Francaise.' );
INSERT INTO PROPERTY VALUES('22222',
700,
5,
3,
2,
'Gas',
'No Cooling',
'Two little houses with dependencies.
Backyard and swimming pool.' );
INSERT INTO PROPERTY VALUES('33333',
600,
4,
2,
2,
'Electric',
'Evaporative Cooler',
'Painting gallery. completely
remodeled. Great for exhibition.' );
INSERT INTO PROPERTY VALUES('44444',
500,
3,
2,
1,
'Propane Gas',
'Room Air Conditioner',
'The "Versailles" of the area.
Many fountains a springs.
Nice for showing off' );
INSERT INTO PROPERTY VALUES('55555',
400,
2,
1,
1,
'Solar',
'Evaportative Cooler',
'Clean and simple.
But very affordable' );
INSERT INTO PROPERTY VALUES('66666',
300,
1,
1,
1,
'Oil',
'No Cooling',
'A best deal in
this range of price!');
INSERT INTO PROPERTY_ADDRESS VALUES('11111',
'7 San Francisco Way',
'Almaden',
'San Jose',
'CA',
'95136' );
INSERT INTO PROPERTY_ADDRESS VALUES('22222',
'234 Redwood Avenue',
'Tenessee',
'Morgan Hill',
'CA',
'91116' );
INSERT INTO PROPERTY_ADDRESS VALUES('33333',
'12 Fortune Road',
'Tropico',
'Los Gatos',
'CA',
'93456' );
INSERT INTO PROPERTY_ADDRESS VALUES('44444',
'134 Onmy Way',
'New Island',
'Saratoga',
'CA',
'95136' );
INSERT INTO PROPERTY_ADDRESS VALUES('55555',
'4 Camden Way',
'Castro',
'San Francisco',
'CA',
'92341' );
INSERT INTO PROPERTY_ADDRESS VALUES('66666',
'78 7th Avenue',
'Cherry Trees',
'New York',
'NY',
'98906' );
INSERT INTO MARKETING_INFO VALUES('11111',
5672000,
5,
5.25,
5.5);
INSERT INTO MARKETING_INFO VALUES('22222',
123000,
4,
8.40,
10.0);
INSERT INTO MARKETING_INFO VALUES('33333',
500000,
9,
2.5,
6.5);
INSERT INTO MARKETING_INFO VALUES('44444',
1000000,
1,
1.4,
3.5);
INSERT INTO MARKETING_INFO VALUES('55555',
679000,
2,
5.75,
5.3);
INSERT INTO MARKETING_INFO VALUES('66666',
1200000,
6,
1.25,
4.5);
INSERT INTO PROPERTY_LOG VALUES('11111',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO PROPERTY_LOG VALUES('22222',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO PROPERTY_LOG VALUES('33333',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO PROPERTY_LOG VALUES('44444',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO PROPERTY_LOG VALUES('55555',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO PROPERTY_LOG VALUES('66666',
'1995-12-30-17.01.35.00000',
'1996-01-06-15.11.32.00000',
'AVAILABLE' );
INSERT INTO MULTIDOC VALUES('11111',
'',
'VIDEO' );
INSERT INTO MULTIDOC VALUES('22222',
'',
'VIDEO' );
INSERT INTO MULTIDOC VALUES('33333',
'',
'VIDEO' );
INSERT INTO MULTIDOC VALUES('44444',
'',
'VIDEO' );
INSERT INTO MULTIDOC VALUES('55555',
'',
'VIDEO' );
INSERT INTO MULTIDOC VALUES('66666',
'',
'VIDEO' );
